HsBuildingImages

Logical Entity Name | HsBuildingImages
Default Table Name | HsBuildingImages
Physical Only | NO
Owner | dbo
Definition |
Note |

HsBuildingImages Columns

ColumnName | Domain | Datatype | NULL | Definition
HsBuildingImagesID |  | int | NO |
HsBuildingID |  | int | NO |
HsSuiteCategoriesID |  | int | YES |
HsRoomCategoriesID |  | int | YES |
SuiteImage |  | image | YES |
RoomImage |  | image | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
Ts |  | timestamp | NO |

HsBuildingImages Primary and Unique Keys

Key Name | Key Type | Keys
PK_HsBuildingImages_HsBuildingImagesID | PrimaryKey | HsBuildingImagesID

HsBuildingImages Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
HsBuilding | Non-Identifying | One To Zero or More | FK_HsBuildingImages_HsBuildingID_HsBuilding_HsBuildingID |  |  | HsBuildingID | NO | YES
HsRoomCategories | Non-Identifying | Zero or One to Zero or More | FK_HsBuildingImages_HsRoomCategoriesID_HsRoomCategories_HsRoomCategoriesID |  |  | HsRoomCategoriesID | NO | YES
HsSuiteCategories | Non-Identifying | Zero or One to Zero or More | FK_HsBuildingImages_HsSuiteCategoriesID_HsSuiteCategories_HsSuiteCategoriesID |  |  | HsSuiteCategoriesID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_HsBuildingImages_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

HsBuildingImages Check Constraints

Check Constraint Name | CheckConstraint

HsBuildingImages Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

HsBuildingImages Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.HsBuildingImages | NO |  |  |
Physical (Microsoft SQL Server) dbo.HsBuildingImages | NO |  |  |

HsBuildingImages Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Housing

HsBuildingImages Data Movement Rules

Name | Type | Rule Text/Value